MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Object Name = 776

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Department, Title, Culture, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Metadata Date Repository
6886 6886 1971.180.54 0 1 7352 American Decorative Arts 1 Wall sconces 776 Pair of wall sconces American or British 3                           1795–1810 1795 1810 Gilded gesso on pine 1155 H. 34 in. (86.4 cm) Bequest of Flora E. Whiting, 1971 Possibly made in|Possibly made in 3       United States|England 6             Furniture 4   http://www.metmuseum.org/art/collection/search/7352 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
6887 6887 1971.180.55 0 1 7353 American Decorative Arts 1 Wall sconces 776 Pair of wall sconces American or British 3                           1795–1810 1795 1810 Gilded gesso on pine 1155 H. 34 1/2 in. (87.6 cm) Bequest of Flora E. Whiting, 1971 Possibly made in|Possibly made in 3       United States|England 6             Furniture 4   http://www.metmuseum.org/art/collection/search/7353 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
110754 110754 41.190.200, .201 0 1 198956 European Sculpture and Decorative Arts 3 Wall sconces 776 Pair of wall sconces probably French 203                           third quarter 18th century 1750 1775 Brass, water-gilt (?), porcelain 22285 Height (each): 26 1/4 in. (66.7 cm) Bequest of George Blumenthal, 1941                       Metalwork-Brass 17   http://www.metmuseum.org/art/collection/search/198956 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
110794 110794 41.190.484, .485 0 1 199004 European Sculpture and Decorative Arts 3 Wall sconces 776 Pair of wall sconces Spanish 13                           17th–18th century 1600 1799 Wrought iron 18 Length (.484): 42 3/4 in. (108.6 cm); Length (.485): 42 1/4 in. (107.3 cm) Bequest of George Blumenthal, 1941                       Metalwork-Iron 322   http://www.metmuseum.org/art/collection/search/199004 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
111517 111517 46.193.5a, b, .6a, b 0 1 199779 European Sculpture and Decorative Arts 3 Wall sconces 776 Pair of wall sconces Italian or French 687                           late 17th–early 18th century 1685 1715 Gilt bronze 30 Height (each): 21 1/4 in. (54 cm) Gift of Susan Dwight Bliss, 1946                       Metalwork-Gilt Bronze 323   http://www.metmuseum.org/art/collection/search/199779 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
113588 113588 56.122.1, .2 0 1 201899 European Sculpture and Decorative Arts 3 Wall sconces 776 Pair of wall sconces British 6                           ca. 1755 1750 1760 Gilded pine, brass 22638 Height: 82 in. (208.3 cm) Purchase, Morris Loeb Bequest, 1956                       Woodwork-Furniture 321   http://www.metmuseum.org/art/collection/search/201899 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
113637 113637 57.1.1a–g–.6a–g 0 1 201953 European Sculpture and Decorative Arts 3 Wall sconces 776 Set of six wall sconces French 7                           1774–93 1774 1793 Gilt bronze 30 Height (.1): 20 7/8 in. (53 cm); Height (.2): 20 7/8 in. (53 cm); Height (.3): 20 15/16 in. (53.2 cm); Height (.4): 21 1/16 in. (53.5 cm); Height (.5): 21 1/8 in. (53.7 cm); Height (.6): 21 in. (53.3 cm) Purchase, Morris Loeb Bequest, 1957                       Metalwork-Gilt Bronze 323   http://www.metmuseum.org/art/collection/search/201953 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
115383 115383 64.101.1488, .1489 0 1 203960 European Sculpture and Decorative Arts 3 Wall sconces 776 Pair of wall sconces Northern Italian 622                           mid-18th century 1730 1765 Wrought iron, painted and gilded 22930 Height: 12 1/2 in. (31.8 cm) Gift of Irwin Untermyer, 1964                       Metalwork-Iron 322   http://www.metmuseum.org/art/collection/search/203960 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
116812 116812 1974.28.65, .66 0 1 205585 European Sculpture and Decorative Arts 3 Wall sconces 776 Pair of wall sconces British 6                           ca. 1730 1725 1735 Gilt gesso on pine, gilt bronze and silk embroidery 23226 Overall (each): 28 × 10 1/2 in. (71.1 × 26.7 cm) Bequest of Irwin Untermyer, 1973                       Woodwork-Furniture 321   http://www.metmuseum.org/art/collection/search/205585 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 127.63ms · Data license: CC0 · Data source: metmuseum/openaccess